﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DailyUpdate.aspx.cs" Inherits="PMP.Report.DailyUpdate" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Daily Update</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    <asp:Button ID="btnRefresh" runat="server" Text="Refresh" 
            onclick="btnRefresh_Click" />
    
    </div>
    <asp:GridView ID="grvFinalReviews" runat="server" AutoGenerateColumns="False" 
        CellPadding="4" ForeColor="#333333" >
        <RowStyle BackColor="#EFF3FB" />
        <Columns>
            <asp:BoundField DataField="In Review(Days)" HeaderText="In Review(Days)" 
                ReadOnly="True" SortExpression="In Review(Days)" />
            <asp:BoundField DataField="Priority" HeaderText="Priority" ReadOnly="True" 
                SortExpression="Priority" />
            <asp:BoundField DataField="Reviewer" HeaderText="Reviewer" ReadOnly="True" 
                SortExpression="Reviewer" />
            <asp:BoundField DataField="Type" HeaderText="Type" ReadOnly="True" 
                SortExpression="Type" />
            <asp:HyperLinkField DataNavigateUrlFields="JIRA" 
                    DataNavigateUrlFormatString="http://jira.redprairie.com/browse/{0}" 
                    DataTextField="JIRA" HeaderText="JIRA" 
                    NavigateUrl="http://jira.redprairie.com/browse/{0}" Text="JIRA" />
            <asp:BoundField DataField="assignee" HeaderText="assignee" ReadOnly="True" 
                SortExpression="assignee" />
        </Columns>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#2461BF" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="dummyFinalReviews" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LocalConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:LocalConnectionString.ProviderName %>" SelectCommand="  select top 1
 0 'In Review(Days)',
'HIGH' Priority,
 'rwei' 'Reviewer',
 'Sub-Task' 'Type',
 'TM-10001' JIRA,
 'rwei' assignee
 from goal_dtl"></asp:SqlDataSource>
 <br />
    <asp:GridView ID="grvNMI" runat="server" CellPadding="4" ForeColor="#333333" 
        GridLines="Both" AutoGenerateColumns="False" >
        <RowStyle BackColor="#EFF3FB" />
        <Columns>
            <asp:BoundField DataField="In Need More Info(Days)" 
                HeaderText="In Need More Info(Days)" ReadOnly="True" 
                SortExpression="In Need More Info(Days)" />
            <asp:BoundField DataField="Priority" HeaderText="Priority" ReadOnly="True" 
                SortExpression="Priority" />
            <asp:BoundField DataField="Reporter" HeaderText="Reporter" ReadOnly="True" 
                SortExpression="Reporter" />
            <asp:BoundField DataField="Type" HeaderText="Type" ReadOnly="True" 
                SortExpression="Type" />
            <asp:HyperLinkField DataNavigateUrlFields="JIRA" 
                    DataNavigateUrlFormatString="http://jira.redprairie.com/browse/{0}" 
                    DataTextField="JIRA" HeaderText="JIRA" 
                    NavigateUrl="http://jira.redprairie.com/browse/{0}" Text="JIRA" />
            <asp:BoundField DataField="assignee" HeaderText="assignee" ReadOnly="True" 
                SortExpression="assignee" />
        </Columns>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#2461BF" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="dummyNMI" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LocalConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:LocalConnectionString.ProviderName %>" SelectCommand="  select top 1
 0 'In Need More Info(Days)',
 'High' Priority,
 'rwei' 'Reporter',
 'Sub-Task' 'Type',
 'TM-10001' JIRA,
 'rwei' assignee
 from goal_dtl"></asp:SqlDataSource>
 <br />
    <asp:GridView ID="grvPeerReviews" runat="server" AutoGenerateColumns="False" 
        CellPadding="4" ForeColor="#333333" 
        GridLines="Both">
        <RowStyle BackColor="#EFF3FB" />
        <Columns>
            <asp:BoundField DataField="Reviewer" HeaderText="Reviewer" ReadOnly="True" 
                SortExpression="Reviewer" />
            <asp:BoundField DataField="StoryPriority" HeaderText="StoryPriority" 
                ReadOnly="True" SortExpression="StoryPriority" />
            <asp:BoundField DataField="Priority" HeaderText="Priority" ReadOnly="True" 
                SortExpression="Priority" />
            <asp:BoundField DataField="Type" HeaderText="Type" ReadOnly="True" 
                SortExpression="Type" />
            <asp:BoundField DataField="Status" HeaderText="Status" ReadOnly="True" 
                SortExpression="Status" />
            <asp:HyperLinkField DataNavigateUrlFields="JIRA" 
                    DataNavigateUrlFormatString="http://jira.redprairie.com/browse/{0}" 
                    DataTextField="JIRA" HeaderText="JIRA" 
                    NavigateUrl="http://jira.redprairie.com/browse/{0}" Text="JIRA" />
            <asp:BoundField DataField="Description" HeaderText="Description" 
                ReadOnly="True" SortExpression="Description" />
            <asp:BoundField DataField="assignee" HeaderText="assignee" ReadOnly="True" 
                SortExpression="assignee" />
        </Columns>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#2461BF" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSourcePeerReview" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LocalConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:LocalConnectionString.ProviderName %>" SelectCommand="select top 1
 'rwei' Reviewer,
 'HIGH' StoryPriority,
 'Major' Priority,
 'Bug' 'Type',
 'In Progress' Status,
 'TM-10001' JIRA,
 'Description' Description,
 'rwei' assignee
from burndown"></asp:SqlDataSource>
 <br />
    <asp:GridView ID="grvReopens" runat="server" AutoGenerateColumns="False" 
        CellPadding="4"  ForeColor="#333333" 
        GridLines="Both">
        <RowStyle BackColor="#EFF3FB" />
        <Columns>
            <asp:BoundField DataField="Reviewer" HeaderText="Reviewer" ReadOnly="True" 
                SortExpression="Reviewer" />
            <asp:BoundField DataField="StoryPriority" HeaderText="StoryPriority" 
                ReadOnly="True" SortExpression="StoryPriority" />
            <asp:BoundField DataField="Priority" HeaderText="Priority" ReadOnly="True" 
                SortExpression="Priority" />
            <asp:BoundField DataField="Type" HeaderText="Type" ReadOnly="True" 
                SortExpression="Type" />
            <asp:BoundField DataField="Status" HeaderText="Status" ReadOnly="True" 
                SortExpression="Status" />
            <asp:HyperLinkField DataNavigateUrlFields="JIRA" 
                    DataNavigateUrlFormatString="http://jira.redprairie.com/browse/{0}" 
                    DataTextField="JIRA" HeaderText="JIRA" 
                    NavigateUrl="http://jira.redprairie.com/browse/{0}" Text="JIRA" />
            <asp:BoundField DataField="Description" HeaderText="Description" 
                ReadOnly="True" SortExpression="Description" />
            <asp:BoundField DataField="assignee" HeaderText="assignee" ReadOnly="True" 
                SortExpression="assignee" />
        </Columns>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#2461BF" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSourceReopen" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LocalConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:LocalConnectionString.ProviderName %>" SelectCommand="select top 1
 'rwei' Reviewer,
 'HIGH' StoryPriority,
 'Major' Priority,
 'Bug' 'Type',
 'In Progress' Status,
 'TM-10001' JIRA,
 'Description' Description,
 'rwei' assignee
from burndown"></asp:SqlDataSource>
    <p>
        <asp:TextBox ID="txtSprint" runat="server" Visible="False"></asp:TextBox>
    </p>
    </form>
</body>
</html>
